PREVIEW / etf_30min / 2012-11-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-09.parquet
  size:    299 KB
  rows:    10,139

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-11-09 04:00:00	SPY	ETF	138.26	138.33	138.12	138.13	7800.0
2012-11-09 04:30:00	SPY	ETF	138.29	138.43	138.29	138.43	12150.0
2012-11-09 05:00:00	SPY	ETF	138.44	138.44	138.0	138.16	30065.0
2012-11-09 05:30:00	SPY	ETF	138.07	138.09	137.82	137.85	27371.0
2012-11-09 06:00:00	SPY	ETF	137.8	138.05	137.72	138.05	83225.0
2012-11-09 06:30:00	SPY	ETF	138.05	138.05	137.86	137.86	27900.0
2012-11-09 07:00:00	SPY	ETF	137.8	137.89	137.76	137.84	135574.0
2012-11-09 07:30:00	SPY	ETF	137.87	137.87	137.35	137.38	561945.0
2012-11-09 08:00:00	SPY	ETF	137.41	138.7	137.01	137.33	2729300.0
2012-11-09 08:30:00	SPY	ETF	137.35	137.69	137.32	137.52	1332698.0
2012-11-09 09:00:00	SPY	ETF	137.52	137.84	137.51	137.62	1586944.0
2012-11-09 09:30:00	SPY	ETF	137.62	138.17	137.55	138.01	25034510.0
2012-11-09 10:00:00	SPY	ETF	138.01	138.669	137.95	138.52	17863807.0
2012-11-09 10:30:00	SPY	ETF	138.52	138.8	138.31	138.67	11603504.0
2012-11-09 11:00:00	SPY	ETF	138.665	138.91	138.54	138.725	10380550.0
2012-11-09 11:30:00	SPY	ETF	138.73	139.0	138.62	138.94	10180825.0
2012-11-09 12:00:00	SPY	ETF	138.94	139.39	138.94	139.34	9080995.0
2012-11-09 12:30:00	SPY	ETF	139.33	139.44	139.13	139.1892	6677191.0
2012-11-09 13:00:00	SPY	ETF	139.18	139.3289	138.31	138.36	20675737.0
2012-11-09 13:30:00	SPY	ETF	138.36	138.63	138.11	138.5501	15653499.0
2012-11-09 14:00:00	SPY	ETF	138.555	138.77	138.31	138.75	6931298.0
2012-11-09 14:30:00	SPY	ETF	138.745	139.09	138.47	138.54	7860297.0
2012-11-09 15:00:00	SPY	ETF	138.535	138.59	138.31	138.57	7508529.0
2012-11-09 15:30:00	SPY	ETF	138.565	138.78	138.13	138.19	29008924.0
2012-11-09 16:00:00	SPY	ETF	138.19	139.3006	138.037	138.2	12454244.0
2012-11-09 16:30:00	SPY	ETF	138.21	138.6741	138.15	138.16	1831630.0
2012-11-09 17:00:00	SPY	ETF	138.18	138.18	137.98	138.02	535991.0
2012-11-09 17:30:00	SPY	ETF	138.03	138.06	137.94	137.95	106030.0
2012-11-09 18:00:00	SPY	ETF	137.98	138.04	137.91	137.97	62725.0
2012-11-09 18:30:00	SPY	ETF	137.97	138.1	137.95	138.0	26464.0
2012-11-09 19:00:00	SPY	ETF	138.06	138.09	138.03	138.03	5740.0
2012-11-09 19:30:00	SPY	ETF	138.03	138.11	138.03	138.1	9381.0
2012-11-09 04:00:00	QQQ	ETF	63.38	63.38	63.38	63.38	100.0
2012-11-09 05:00:00	QQQ	ETF	63.43	63.43	63.28	63.28	600.0
2012-11-09 05:30:00	QQQ	ETF	63.3	63.3	63.22	63.22	400.0
2012-11-09 06:00:00	QQQ	ETF	63.2	63.27	63.2	63.27	500.0
2012-11-09 06:30:00	QQQ	ETF	63.29	63.29	63.23	63.27	10500.0
2012-11-09 07:00:00	QQQ	ETF	63.22	63.22	63.18	63.21	9946.0
2012-11-09 07:30:00	QQQ	ETF	63.21	63.21	63.0	63.0	33560.0
2012-11-09 08:00:00	QQQ	ETF	63.03	63.03	62.86	63.03	178830.0
2012-11-09 08:30:00	QQQ	ETF	63.03	63.15	63.03	63.08	439972.0
2012-11-09 09:00:00	QQQ	ETF	63.09	63.26	63.09	63.19	511239.0
2012-11-09 09:30:00	QQQ	ETF	63.19	63.46	63.16	63.31	5936411.0
2012-11-09 10:00:00	QQQ	ETF	63.319	63.64	63.28	63.56	6268823.0
2012-11-09 10:30:00	QQQ	ETF	63.57	63.76	63.48	63.72	3397867.0
2012-11-09 11:00:00	QQQ	ETF	63.72	63.82	63.63	63.73	2530371.0
2012-11-09 11:30:00	QQQ	ETF	63.73	63.83	63.68	63.77	1867900.0
2012-11-09 12:00:00	QQQ	ETF	63.77	64.05	63.77	64.02	2635073.0
2012-11-09 12:30:00	QQQ	ETF	64.02	64.11	63.93	63.96	1362478.0
2012-11-09 13:00:00	QQQ	ETF	63.965	64.039	63.55	63.5601	3657731.0

> showing 50 of 10,139 rows — these rows as CSV

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