PREVIEW / etf_30min / 2012-03-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-14.parquet
  size:    295 KB
  rows:    9,803

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
2012-03-14 04:00:00	SPY	ETF	139.97	140.06	139.93	139.93	2060.0
2012-03-14 04:30:00	SPY	ETF	139.9	140.03	139.9	140.03	20890.0
2012-03-14 05:00:00	SPY	ETF	140.06	140.2	140.06	140.18	28075.0
2012-03-14 05:30:00	SPY	ETF	140.15	140.17	140.08	140.17	50800.0
2012-03-14 06:00:00	SPY	ETF	140.15	140.23	140.15	140.22	26800.0
2012-03-14 06:30:00	SPY	ETF	140.24	140.37	140.24	140.37	104200.0
2012-03-14 07:00:00	SPY	ETF	140.37	140.39	140.25	140.29	105125.0
2012-03-14 07:30:00	SPY	ETF	140.27	140.27	140.01	140.01	221434.0
2012-03-14 08:00:00	SPY	ETF	140.02	140.21	139.99	140.09	1269528.0
2012-03-14 08:30:00	SPY	ETF	140.09	140.14	139.93	140.14	849020.0
2012-03-14 09:00:00	SPY	ETF	140.13	140.17	140.07	140.1	951627.0
2012-03-14 09:30:00	SPY	ETF	140.1	140.34	140.0	140.29	15940039.0
2012-03-14 10:00:00	SPY	ETF	140.28	140.445	140.19	140.279	16158235.0
2012-03-14 10:30:00	SPY	ETF	140.28	140.32	139.98	140.0	10155860.0
2012-03-14 11:00:00	SPY	ETF	140.01	140.043	139.81	139.88	8531172.0
2012-03-14 11:30:00	SPY	ETF	139.88	139.95	139.79	139.93	7515155.0
2012-03-14 12:00:00	SPY	ETF	139.93	139.98	139.82	139.85	4918529.0
2012-03-14 12:30:00	SPY	ETF	139.85	140.1	139.82	140.07	5419294.0
2012-03-14 13:00:00	SPY	ETF	140.06	140.31	140.03	140.28	5964951.0
2012-03-14 13:30:00	SPY	ETF	140.28	140.28	139.67	139.7	11089989.0
2012-03-14 14:00:00	SPY	ETF	139.7	139.84	139.55	139.7	11497445.0
2012-03-14 14:30:00	SPY	ETF	139.7	139.84	139.59	139.765	6637323.0
2012-03-14 15:00:00	SPY	ETF	139.7519	139.82	139.48	139.8	8063321.0
2012-03-14 15:30:00	SPY	ETF	139.8	139.95	139.71	139.92	17691399.0
2012-03-14 16:00:00	SPY	ETF	139.92	140.42	139.75	139.86	5762219.0
2012-03-14 16:30:00	SPY	ETF	139.85	139.85	139.68	139.71	2629904.0
2012-03-14 17:00:00	SPY	ETF	139.7	139.7	139.53	139.54	168060.0
2012-03-14 17:30:00	SPY	ETF	139.56	139.63	139.56	139.6	1078438.0
2012-03-14 18:00:00	SPY	ETF	139.58	139.68	139.55	139.68	104775.0
2012-03-14 18:30:00	SPY	ETF	139.67	139.7	139.63	139.7	9436.0
2012-03-14 19:00:00	SPY	ETF	139.7	139.75	139.7	139.71	24030.0
2012-03-14 19:30:00	SPY	ETF	139.72	139.78	139.72	139.74	26500.0
2012-03-14 04:00:00	QQQ	ETF	66.2	66.2	66.2	66.2	100.0
2012-03-14 06:00:00	QQQ	ETF	66.25	66.25	66.25	66.25	200.0
2012-03-14 06:30:00	QQQ	ETF	66.34	66.37	66.34	66.36	2300.0
2012-03-14 07:00:00	QQQ	ETF	66.36	66.36	66.28	66.28	38300.0
2012-03-14 07:30:00	QQQ	ETF	66.27	66.28	66.17	66.18	132769.0
2012-03-14 08:00:00	QQQ	ETF	66.18	66.36	66.17	66.21	872757.0
2012-03-14 08:30:00	QQQ	ETF	66.2	66.26	66.17	66.26	81631.0
2012-03-14 09:00:00	QQQ	ETF	66.26	66.33	66.24	66.33	420619.0
2012-03-14 09:30:00	QQQ	ETF	66.32	66.53	66.28	66.4601	7257366.0
2012-03-14 10:00:00	QQQ	ETF	66.46	66.5916	66.4	66.48	5729660.0
2012-03-14 10:30:00	QQQ	ETF	66.49	66.64	66.475	66.51	3544161.0
2012-03-14 11:00:00	QQQ	ETF	66.52	66.54	66.42	66.44	2311838.0
2012-03-14 11:30:00	QQQ	ETF	66.4393	66.44	66.35	66.42	2525742.0
2012-03-14 12:00:00	QQQ	ETF	66.43	66.46	66.34	66.36	1707050.0
2012-03-14 12:30:00	QQQ	ETF	66.3562	66.55	66.3416	66.528	1793413.0
2012-03-14 13:00:00	QQQ	ETF	66.52	66.74	66.49	66.7	3560170.0
2012-03-14 13:30:00	QQQ	ETF	66.695	66.71	66.3	66.35	5248137.0
2012-03-14 14:00:00	QQQ	ETF	66.34	66.41	66.08	66.27	5470810.0

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

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