PREVIEW / etf_30min / 2011-07-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-21.parquet
  size:    285 KB
  rows:    9,521

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-07-21 04:00:00	SPY	ETF	132.52	132.52	132.52	132.52	100.0
2011-07-21 04:30:00	SPY	ETF	132.64	132.64	132.54	132.6	400.0
2011-07-21 05:00:00	SPY	ETF	132.6	132.6	132.16	132.17	4361.0
2011-07-21 05:30:00	SPY	ETF	132.1	132.18	132.1	132.18	15800.0
2011-07-21 06:00:00	SPY	ETF	132.19	132.21	132.05	132.2	66400.0
2011-07-21 06:30:00	SPY	ETF	132.2	132.56	132.2	132.56	26500.0
2011-07-21 07:00:00	SPY	ETF	132.61	132.82	132.6	132.77	246000.0
2011-07-21 07:30:00	SPY	ETF	132.75	133.0	132.57	133.0	1230220.0
2011-07-21 08:00:00	SPY	ETF	132.98	133.47	132.87	133.25	4904829.0
2011-07-21 08:30:00	SPY	ETF	133.25	133.63	133.09	133.5	4200447.0
2011-07-21 09:00:00	SPY	ETF	133.5	133.58	133.34	133.4	1840593.0
2011-07-21 09:30:00	SPY	ETF	133.4	133.95	133.14	133.83	21122597.0
2011-07-21 10:00:00	SPY	ETF	133.84	134.61	133.68	134.56	26757729.0
2011-07-21 10:30:00	SPY	ETF	134.56	134.61	134.23	134.37	16441703.0
2011-07-21 11:00:00	SPY	ETF	134.38	134.44	134.05	134.14	13776955.0
2011-07-21 11:30:00	SPY	ETF	134.14	134.17	133.92	134.085	10690180.0
2011-07-21 12:00:00	SPY	ETF	134.08	134.2	133.93	134.06	7987413.0
2011-07-21 12:30:00	SPY	ETF	134.06	134.82	134.03	134.57	34379618.0
2011-07-21 13:00:00	SPY	ETF	134.57	134.77	134.41	134.76	16994676.0
2011-07-21 13:30:00	SPY	ETF	134.76	134.76	134.43	134.6	6713737.0
2011-07-21 14:00:00	SPY	ETF	134.6	134.65	134.37	134.4702	7924143.0
2011-07-21 14:30:00	SPY	ETF	134.48	134.68	134.39	134.63	9527167.0
2011-07-21 15:00:00	SPY	ETF	134.63	134.72	134.39	134.64	14180278.0
2011-07-21 15:30:00	SPY	ETF	134.64	134.65	134.38	134.49	25022692.0
2011-07-21 16:00:00	SPY	ETF	134.49	134.79	134.3168	134.55	18045074.0
2011-07-21 16:30:00	SPY	ETF	134.55	134.89	134.55	134.79	737553.0
2011-07-21 17:00:00	SPY	ETF	134.79	134.9	134.76	134.87	87290.0
2011-07-21 17:30:00	SPY	ETF	134.85	134.87	134.8	134.84	19870.0
2011-07-21 18:00:00	SPY	ETF	134.84	134.87	134.52	134.87	399894.0
2011-07-21 18:30:00	SPY	ETF	134.87	134.9	134.82	134.83	35229.0
2011-07-21 19:00:00	SPY	ETF	134.85	134.86	134.8	134.84	35003.0
2011-07-21 19:30:00	SPY	ETF	134.83	134.9	134.8	134.9	31057.0
2011-07-21 06:00:00	QQQ	ETF	58.25	58.25	58.22	58.22	1400.0
2011-07-21 06:30:00	QQQ	ETF	58.2	58.25	58.2	58.25	11000.0
2011-07-21 07:00:00	QQQ	ETF	58.36	58.4	58.32	58.4	53600.0
2011-07-21 07:30:00	QQQ	ETF	58.4	58.54	58.35	58.54	520604.0
2011-07-21 08:00:00	QQQ	ETF	58.41	58.73	58.41	58.66	2085919.0
2011-07-21 08:30:00	QQQ	ETF	58.65	58.86	58.61	58.76	699973.0
2011-07-21 09:00:00	QQQ	ETF	58.77	58.81	58.66	58.66	724262.0
2011-07-21 09:30:00	QQQ	ETF	58.65	58.87	58.34	58.73	11455322.0
2011-07-21 10:00:00	QQQ	ETF	58.72	59.32	58.64	59.28	9509973.0
2011-07-21 10:30:00	QQQ	ETF	59.28	59.31	59.19	59.2	3559857.0
2011-07-21 11:00:00	QQQ	ETF	59.2	59.24	58.96	58.99	3282182.0
2011-07-21 11:30:00	QQQ	ETF	58.98	59.04	58.79	58.88	3433416.0
2011-07-21 12:00:00	QQQ	ETF	58.8899	58.97	58.85	58.91	1135603.0
2011-07-21 12:30:00	QQQ	ETF	58.9	59.245	58.89	59.11	6065710.0
2011-07-21 13:00:00	QQQ	ETF	59.11	59.16	59.0	59.155	1354109.0
2011-07-21 13:30:00	QQQ	ETF	59.1592	59.16	59.0	59.1	1014868.0
2011-07-21 14:00:00	QQQ	ETF	59.1	59.14	58.94	59.01	1342152.0
2011-07-21 14:30:00	QQQ	ETF	59.01	59.14	58.97	59.11	2878091.0

> showing 50 of 9,521 rows — these rows as CSV

> unlock the full archive -- $79 one-time