PREVIEW / etf_30min / 2011-04-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-27.parquet
  size:    285 KB
  rows:    9,375

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-04-27 04:00:00	SPY	ETF	134.62	134.62	134.57	134.57	300.0
2011-04-27 04:30:00	SPY	ETF	134.73	134.73	134.73	134.73	200.0
2011-04-27 05:00:00	SPY	ETF	134.88	134.88	134.86	134.86	225.0
2011-04-27 05:30:00	SPY	ETF	134.99	135.0	134.99	135.0	425.0
2011-04-27 06:00:00	SPY	ETF	134.92	134.96	134.92	134.93	500.0
2011-04-27 06:30:00	SPY	ETF	134.94	135.04	134.93	135.0	32250.0
2011-04-27 07:00:00	SPY	ETF	135.01	135.06	134.97	135.04	110660.0
2011-04-27 07:30:00	SPY	ETF	135.04	135.06	134.89	134.93	388595.0
2011-04-27 08:00:00	SPY	ETF	134.93	134.97	134.84	134.92	2032700.0
2011-04-27 08:30:00	SPY	ETF	134.95	135.05	134.95	135.03	637753.0
2011-04-27 09:00:00	SPY	ETF	135.03	135.11	135.03	135.05	851538.0
2011-04-27 09:30:00	SPY	ETF	135.05	135.1	134.83	134.91	12873098.0
2011-04-27 10:00:00	SPY	ETF	134.91	134.92	134.63	134.73	9054581.0
2011-04-27 10:30:00	SPY	ETF	134.74	134.75	134.5	134.52	8632519.0
2011-04-27 11:00:00	SPY	ETF	134.53	134.71	134.52	134.69	4931722.0
2011-04-27 11:30:00	SPY	ETF	134.7	134.8	134.6	134.7101	5333560.0
2011-04-27 12:00:00	SPY	ETF	134.72	134.76	134.64	134.66	3140973.0
2011-04-27 12:30:00	SPY	ETF	134.65	135.06	134.57	134.96	14721542.0
2011-04-27 13:00:00	SPY	ETF	134.96	135.12	134.89	134.9799	5651312.0
2011-04-27 13:30:00	SPY	ETF	134.9799	135.16	134.91	135.14	5880262.0
2011-04-27 14:00:00	SPY	ETF	135.12	135.2	134.87	134.905	9133246.0
2011-04-27 14:30:00	SPY	ETF	134.91	135.3	134.9	135.2738	9659334.0
2011-04-27 15:00:00	SPY	ETF	135.28	135.45	135.25	135.41	8467523.0
2011-04-27 15:30:00	SPY	ETF	135.415	135.87	135.41	135.62	23863353.0
2011-04-27 16:00:00	SPY	ETF	135.62	135.68	134.66	135.6	12514059.0
2011-04-27 16:30:00	SPY	ETF	135.6	135.65	135.55	135.6	2194296.0
2011-04-27 17:00:00	SPY	ETF	135.63	135.65	135.6	135.6	178060.0
2011-04-27 17:30:00	SPY	ETF	135.65	135.65	135.58	135.61	37059.0
2011-04-27 18:00:00	SPY	ETF	135.63	135.65	135.6	135.62	110918.0
2011-04-27 18:30:00	SPY	ETF	135.63	135.65	135.63	135.64	15340.0
2011-04-27 19:00:00	SPY	ETF	135.64	135.64	135.58	135.59	41146.0
2011-04-27 19:30:00	SPY	ETF	135.6	135.64	135.56	135.64	35465.0
2011-04-27 04:30:00	QQQ	ETF	58.81	58.81	58.81	58.81	2000.0
2011-04-27 06:30:00	QQQ	ETF	58.92	59.0	58.92	59.0	27200.0
2011-04-27 07:00:00	QQQ	ETF	58.97	59.01	58.94	58.99	49922.0
2011-04-27 07:30:00	QQQ	ETF	58.95	58.96	58.92	58.92	553653.0
2011-04-27 08:00:00	QQQ	ETF	58.92	58.93	58.88	58.91	3474939.0
2011-04-27 08:30:00	QQQ	ETF	58.91	58.96	58.91	58.96	427331.0
2011-04-27 09:00:00	QQQ	ETF	58.96	58.99	58.83	58.91	261188.0
2011-04-27 09:30:00	QQQ	ETF	58.92	59.02	58.8512	58.92	5201388.0
2011-04-27 10:00:00	QQQ	ETF	58.92	58.93	58.72	58.77	2601812.0
2011-04-27 10:30:00	QQQ	ETF	58.78	58.78	58.66	58.695	2411095.0
2011-04-27 11:00:00	QQQ	ETF	58.6933	58.81	58.69	58.7625	1288557.0
2011-04-27 11:30:00	QQQ	ETF	58.76	58.86	58.7499	58.801	1103206.0
2011-04-27 12:00:00	QQQ	ETF	58.8	58.83	58.76	58.7731	816294.0
2011-04-27 12:30:00	QQQ	ETF	58.77	58.95	58.74	58.94	4139238.0
2011-04-27 13:00:00	QQQ	ETF	58.94	59.0	58.9	58.92	1948320.0
2011-04-27 13:30:00	QQQ	ETF	58.92	59.0	58.89	58.9784	1783249.0
2011-04-27 14:00:00	QQQ	ETF	58.98	59.01	58.89	58.9	2219072.0
2011-04-27 14:30:00	QQQ	ETF	58.91	59.09	58.9094	59.0885	3013687.0

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

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