PREVIEW / etf_30min / 2013-05-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-23.parquet
  size:    338 KB
  rows:    11,284

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
2013-05-23 04:00:00	SPY	ETF	164.85	164.85	163.97	164.01	109871.0
2013-05-23 04:30:00	SPY	ETF	163.92	164.28	163.81	164.04	49244.0
2013-05-23 05:00:00	SPY	ETF	164.04	164.35	164.04	164.35	49607.0
2013-05-23 05:30:00	SPY	ETF	164.3	164.31	164.16	164.16	75550.0
2013-05-23 06:00:00	SPY	ETF	164.09	164.3	164.04	164.23	61494.0
2013-05-23 06:30:00	SPY	ETF	164.23	164.82	164.21	164.79	330920.0
2013-05-23 07:00:00	SPY	ETF	164.79	165.0	164.67	164.7	525286.0
2013-05-23 07:30:00	SPY	ETF	164.69	164.74	164.36	164.42	731956.0
2013-05-23 08:00:00	SPY	ETF	164.42	164.95	163.74	164.51	1500988.0
2013-05-23 08:30:00	SPY	ETF	164.6	164.83	164.35	164.51	2508012.0
2013-05-23 09:00:00	SPY	ETF	164.51	164.72	164.13	164.15	2273721.0
2013-05-23 09:30:00	SPY	ETF	164.16	164.61	164.03	164.17	29515438.0
2013-05-23 10:00:00	SPY	ETF	164.17	165.04	163.94	164.83	26843968.0
2013-05-23 10:30:00	SPY	ETF	164.83	164.96	164.39	164.5201	13692293.0
2013-05-23 11:00:00	SPY	ETF	164.53	165.44	164.52	165.13	15272658.0
2013-05-23 11:30:00	SPY	ETF	165.13	165.8623	165.06	165.2899	9396573.0
2013-05-23 12:00:00	SPY	ETF	165.29	165.76	165.27	165.45	9995905.0
2013-05-23 12:30:00	SPY	ETF	165.45	165.47	165.14	165.292	8010440.0
2013-05-23 13:00:00	SPY	ETF	165.295	165.4	164.88	164.94	8456015.0
2013-05-23 13:30:00	SPY	ETF	164.94	165.8624	164.81	165.37	9935210.0
2013-05-23 14:00:00	SPY	ETF	165.38	165.8624	165.21	165.49	11647778.0
2013-05-23 14:30:00	SPY	ETF	165.49	165.91	165.22	165.65	12181661.0
2013-05-23 15:00:00	SPY	ETF	165.66	165.81	165.25	165.5	11833057.0
2013-05-23 15:30:00	SPY	ETF	165.5019	165.67	165.19	165.43	19272929.0
2013-05-23 16:00:00	SPY	ETF	165.45	165.8623	165.0	165.53	8150888.0
2013-05-23 16:30:00	SPY	ETF	165.56	165.66	164.9711	165.63	1234632.0
2013-05-23 17:00:00	SPY	ETF	165.62	165.67	165.57	165.65	132301.0
2013-05-23 17:30:00	SPY	ETF	165.64	165.66	165.63	165.64	79580.0
2013-05-23 18:00:00	SPY	ETF	165.63	165.72	165.62	165.65	73620.0
2013-05-23 18:30:00	SPY	ETF	165.65	165.75	165.58	165.74	46567.0
2013-05-23 19:00:00	SPY	ETF	165.71	165.71	165.67	165.67	52130.0
2013-05-23 19:30:00	SPY	ETF	165.68	165.88	165.66	165.83	90966.0
2013-05-23 04:00:00	QQQ	ETF	72.97	73.03	72.75	72.75	15401.0
2013-05-23 04:30:00	QQQ	ETF	72.71	72.86	72.71	72.86	3600.0
2013-05-23 05:00:00	QQQ	ETF	72.74	72.89	72.74	72.89	6800.0
2013-05-23 05:30:00	QQQ	ETF	72.84	72.89	72.84	72.88	35800.0
2013-05-23 06:00:00	QQQ	ETF	72.81	72.84	72.8	72.83	6500.0
2013-05-23 06:30:00	QQQ	ETF	72.86	73.1	72.86	73.1	34500.0
2013-05-23 07:00:00	QQQ	ETF	73.07	73.13	73.05	73.1	16130.0
2013-05-23 07:30:00	QQQ	ETF	73.04	73.06	72.94	72.98	100720.0
2013-05-23 08:00:00	QQQ	ETF	72.98	73.08	72.78	72.99	487754.0
2013-05-23 08:30:00	QQQ	ETF	72.99	73.22	72.99	73.13	333040.0
2013-05-23 09:00:00	QQQ	ETF	73.13	73.21	72.88	72.94	832413.0
2013-05-23 09:30:00	QQQ	ETF	72.95	73.18	72.83	72.929	8101939.0
2013-05-23 10:00:00	QQQ	ETF	72.93	73.5	72.84	73.42	7633556.0
2013-05-23 10:30:00	QQQ	ETF	73.42	73.49	73.16	73.2	3817768.0
2013-05-23 11:00:00	QQQ	ETF	73.2	73.58	73.1937	73.39	2852669.0
2013-05-23 11:30:00	QQQ	ETF	73.39	73.54	73.37	73.473	1061169.0
2013-05-23 12:00:00	QQQ	ETF	73.47	73.63	73.46	73.49	1483105.0
2013-05-23 12:30:00	QQQ	ETF	73.48	73.54	73.38	73.47	1143911.0

> showing 50 of 11,284 rows — these rows as CSV

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