PREVIEW / etf_30min / 2010-11-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-15.parquet
  size:    267 KB
  rows:    8,947

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
2010-11-15 04:00:00	SPY	ETF	120.1	120.1	119.85	120.0	2800.0
2010-11-15 05:00:00	SPY	ETF	120.21	120.21	120.21	120.21	472.0
2010-11-15 06:00:00	SPY	ETF	120.2	120.25	120.2	120.25	329.0
2010-11-15 06:30:00	SPY	ETF	120.3	120.38	120.3	120.35	32615.0
2010-11-15 07:00:00	SPY	ETF	120.36	120.44	120.32	120.38	203850.0
2010-11-15 07:30:00	SPY	ETF	120.39	120.64	120.36	120.6	465825.0
2010-11-15 08:00:00	SPY	ETF	120.59	120.72	119.81	120.59	963199.0
2010-11-15 08:30:00	SPY	ETF	120.54	120.67	116.71	120.54	1770035.0
2010-11-15 09:00:00	SPY	ETF	120.54	120.68	120.46	120.57	796296.0
2010-11-15 09:30:00	SPY	ETF	120.58	120.82	120.44	120.47	20352734.0
2010-11-15 10:00:00	SPY	ETF	120.46	120.65	120.23	120.55	14324037.0
2010-11-15 10:30:00	SPY	ETF	120.56	120.72	120.5	120.56	8823452.0
2010-11-15 11:00:00	SPY	ETF	120.57	120.68	120.4	120.6	9840783.0
2010-11-15 11:30:00	SPY	ETF	120.6096	121.05	120.58	120.95	9725465.0
2010-11-15 12:00:00	SPY	ETF	120.94	121.04	120.66	120.81	10514951.0
2010-11-15 12:30:00	SPY	ETF	120.8	120.94	120.76	120.9	4196114.0
2010-11-15 13:00:00	SPY	ETF	120.9	121.02	120.71	120.925	7541470.0
2010-11-15 13:30:00	SPY	ETF	120.93	120.99	120.84	120.84	3709216.0
2010-11-15 14:00:00	SPY	ETF	120.84	120.93	120.55	120.61	10156030.0
2010-11-15 14:30:00	SPY	ETF	120.61	120.77	120.44	120.66	8819532.0
2010-11-15 15:00:00	SPY	ETF	120.66	120.67	120.14	120.33	16497434.0
2010-11-15 15:30:00	SPY	ETF	120.33	120.38	119.98	120.03	20284661.0
2010-11-15 16:00:00	SPY	ETF	120.02	120.985	120.0	120.0	11177176.0
2010-11-15 16:30:00	SPY	ETF	120.0	120.6619	119.83	119.95	1611210.0
2010-11-15 17:00:00	SPY	ETF	119.93	119.95	119.83	119.83	366375.0
2010-11-15 17:30:00	SPY	ETF	119.85	119.85	119.74	119.85	272266.0
2010-11-15 18:00:00	SPY	ETF	119.85	120.04	119.85	119.91	76666.0
2010-11-15 18:30:00	SPY	ETF	119.92	119.93	119.85	119.85	31649.0
2010-11-15 19:00:00	SPY	ETF	119.88	119.93	119.64	119.68	69591.0
2010-11-15 19:30:00	SPY	ETF	119.67	119.69	119.54	119.64	131575.0
2010-11-15 04:00:00	QQQ	ETF	52.55	52.55	52.55	52.55	10000.0
2010-11-15 04:30:00	QQQ	ETF	52.5	52.5	52.5	52.5	100.0
2010-11-15 06:30:00	QQQ	ETF	52.69	52.7	52.69	52.7	20500.0
2010-11-15 07:00:00	QQQ	ETF	52.71	52.75	52.71	52.73	39720.0
2010-11-15 07:30:00	QQQ	ETF	52.71	52.83	52.71	52.83	62178.0
2010-11-15 08:00:00	QQQ	ETF	52.81	52.85	52.77	52.78	123304.0
2010-11-15 08:30:00	QQQ	ETF	52.76	52.84	52.7	52.78	586981.0
2010-11-15 09:00:00	QQQ	ETF	52.79	52.83	52.74	52.77	316539.0
2010-11-15 09:30:00	QQQ	ETF	52.78	52.88	52.48	52.49	8888474.0
2010-11-15 10:00:00	QQQ	ETF	52.4962	52.5801	52.36	52.52	6859361.0
2010-11-15 10:30:00	QQQ	ETF	52.53	52.61	52.49	52.55	3751464.0
2010-11-15 11:00:00	QQQ	ETF	52.55	52.59	52.39	52.46	3580031.0
2010-11-15 11:30:00	QQQ	ETF	52.47	52.68	52.46	52.64	3312379.0
2010-11-15 12:00:00	QQQ	ETF	52.64	52.68	52.51	52.56	1726578.0
2010-11-15 12:30:00	QQQ	ETF	52.56	52.67	52.53	52.665	1328098.0
2010-11-15 13:00:00	QQQ	ETF	52.66	52.73	52.57	52.67	1848771.0
2010-11-15 13:30:00	QQQ	ETF	52.68	52.73	52.6501	52.66	1114047.0
2010-11-15 14:00:00	QQQ	ETF	52.66	52.69	52.52	52.555	1869188.0
2010-11-15 14:30:00	QQQ	ETF	52.56	52.63	52.49	52.59	2165487.0
2010-11-15 15:00:00	QQQ	ETF	52.59	52.6	52.34	52.405	6451358.0

> showing 50 of 8,947 rows — these rows as CSV

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