PREVIEW / etf_30min / 2011-02-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-10.parquet
  size:    282 KB
  rows:    9,524

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-02-10 04:00:00	SPY	ETF	132.07	132.07	131.6	131.63	4560.0
2011-02-10 04:30:00	SPY	ETF	131.62	131.9	131.49	131.49	4410.0
2011-02-10 05:00:00	SPY	ETF	131.45	131.65	131.45	131.65	53600.0
2011-02-10 05:30:00	SPY	ETF	131.65	131.74	131.63	131.72	17400.0
2011-02-10 06:00:00	SPY	ETF	131.74	131.74	131.58	131.68	38807.0
2011-02-10 06:30:00	SPY	ETF	131.62	131.66	131.51	131.54	61400.0
2011-02-10 07:00:00	SPY	ETF	131.53	131.71	131.53	131.7	359073.0
2011-02-10 07:30:00	SPY	ETF	131.7	131.74	131.59	131.59	289464.0
2011-02-10 08:00:00	SPY	ETF	131.64	131.75	131.54	131.66	947779.0
2011-02-10 08:30:00	SPY	ETF	131.66	131.79	131.5	131.54	2046371.0
2011-02-10 09:00:00	SPY	ETF	131.54	131.68	131.5	131.6	1249627.0
2011-02-10 09:30:00	SPY	ETF	131.6	131.84	131.325	131.53	21550980.0
2011-02-10 10:00:00	SPY	ETF	131.54	132.06	131.3	131.97	18398025.0
2011-02-10 10:30:00	SPY	ETF	131.96	132.2543	131.85	131.87	12791345.0
2011-02-10 11:00:00	SPY	ETF	131.86	132.2	131.81	132.18	10581567.0
2011-02-10 11:30:00	SPY	ETF	132.17	132.34	132.13	132.2019	8333094.0
2011-02-10 12:00:00	SPY	ETF	132.21	132.22	132.08	132.18	3744272.0
2011-02-10 12:30:00	SPY	ETF	132.17	132.27	132.02	132.03	8471438.0
2011-02-10 13:00:00	SPY	ETF	132.03	132.15	131.96	131.96	6691434.0
2011-02-10 13:30:00	SPY	ETF	131.96	132.09	131.88	132.0	6958401.0
2011-02-10 14:00:00	SPY	ETF	131.99	132.21	131.93	132.1499	4904623.0
2011-02-10 14:30:00	SPY	ETF	132.15	132.26	132.02	132.02	4850214.0
2011-02-10 15:00:00	SPY	ETF	132.02	132.24	131.96	132.22	7385827.0
2011-02-10 15:30:00	SPY	ETF	132.22	132.47	131.96	132.33	31680863.0
2011-02-10 16:00:00	SPY	ETF	132.34	132.4391	131.5648	132.19	8422718.0
2011-02-10 16:30:00	SPY	ETF	132.2	132.26	131.85	131.89	1111117.0
2011-02-10 17:00:00	SPY	ETF	131.89	131.9	131.78	131.86	636199.0
2011-02-10 17:30:00	SPY	ETF	131.84	131.87	131.81	131.87	19354.0
2011-02-10 18:00:00	SPY	ETF	131.87	132.33	131.82	131.84	120336.0
2011-02-10 18:30:00	SPY	ETF	131.84	131.91	131.84	131.91	31121.0
2011-02-10 19:00:00	SPY	ETF	131.94	132.02	131.86	131.87	54100.0
2011-02-10 19:30:00	SPY	ETF	131.86	131.93	131.83	131.93	40703.0
2011-02-10 04:00:00	QQQ	ETF	57.55	57.55	57.49	57.52	1500.0
2011-02-10 04:30:00	QQQ	ETF	57.48	57.52	57.46	57.48	6900.0
2011-02-10 05:00:00	QQQ	ETF	57.5	57.52	57.5	57.51	84000.0
2011-02-10 05:30:00	QQQ	ETF	57.55	57.57	57.55	57.57	70700.0
2011-02-10 06:00:00	QQQ	ETF	57.52	57.55	57.52	57.55	10400.0
2011-02-10 06:30:00	QQQ	ETF	57.55	57.57	57.52	57.57	50454.0
2011-02-10 07:00:00	QQQ	ETF	57.56	57.62	57.56	57.61	105185.0
2011-02-10 07:30:00	QQQ	ETF	57.61	57.62	57.54	57.54	74905.0
2011-02-10 08:00:00	QQQ	ETF	57.56	57.58	57.45	57.57	170353.0
2011-02-10 08:30:00	QQQ	ETF	57.59	57.64	57.5	57.52	340888.0
2011-02-10 09:00:00	QQQ	ETF	57.51	57.62	57.49	57.61	347825.0
2011-02-10 09:30:00	QQQ	ETF	57.61	57.66	57.49	57.56	7434855.0
2011-02-10 10:00:00	QQQ	ETF	57.5601	57.97	57.49	57.93	11072555.0
2011-02-10 10:30:00	QQQ	ETF	57.93	57.99	57.87	57.89	2938791.0
2011-02-10 11:00:00	QQQ	ETF	57.885	58.05	57.86	58.03	3725329.0
2011-02-10 11:30:00	QQQ	ETF	58.0396	58.1	58.03	58.06	2785389.0
2011-02-10 12:00:00	QQQ	ETF	58.06	58.09	58.02	58.07	1313402.0
2011-02-10 12:30:00	QQQ	ETF	58.07	58.1	57.96	58.01	4115023.0

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

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