PREVIEW / etf_30min / 2009-09-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-28.parquet
  size:    226 KB
  rows:    7,451

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
2009-09-28 04:00:00	SPY	ETF	104.26	104.37	104.26	104.37	4773.0
2009-09-28 04:30:00	SPY	ETF	104.6	104.6	104.6	104.6	200.0
2009-09-28 05:30:00	SPY	ETF	104.6	104.61	104.56	104.56	300.0
2009-09-28 06:00:00	SPY	ETF	104.72	104.81	104.72	104.81	2400.0
2009-09-28 06:30:00	SPY	ETF	104.82	104.82	104.77	104.79	2400.0
2009-09-28 07:00:00	SPY	ETF	104.8	104.99	104.74	104.93	87897.0
2009-09-28 07:30:00	SPY	ETF	104.95	104.99	104.9	104.92	212609.0
2009-09-28 08:00:00	SPY	ETF	104.9	105.16	104.1	105.1	551494.0
2009-09-28 08:30:00	SPY	ETF	105.11	105.22	104.95	104.97	936657.0
2009-09-28 09:00:00	SPY	ETF	104.96	105.08	104.86	104.86	847009.0
2009-09-28 09:30:00	SPY	ETF	104.85	105.71	104.83	105.6	17881973.0
2009-09-28 10:00:00	SPY	ETF	105.59	105.98	105.59	105.94	13520862.0
2009-09-28 10:30:00	SPY	ETF	105.93	106.15	105.92	106.01	9272076.0
2009-09-28 11:00:00	SPY	ETF	106.0	106.17	105.99	106.16	4872596.0
2009-09-28 11:30:00	SPY	ETF	106.15	106.34	106.15	106.25	6064147.0
2009-09-28 12:00:00	SPY	ETF	106.2401	106.47	106.24	106.33	5870272.0
2009-09-28 12:30:00	SPY	ETF	106.3399	106.43	106.2	106.22	4444392.0
2009-09-28 13:00:00	SPY	ETF	106.21	106.39	106.21	106.38	4305952.0
2009-09-28 13:30:00	SPY	ETF	106.37	106.55	106.26	106.27	5258108.0
2009-09-28 14:00:00	SPY	ETF	106.27	106.4	106.15	106.33	7605261.0
2009-09-28 14:30:00	SPY	ETF	106.33	106.46	106.16	106.17	6355732.0
2009-09-28 15:00:00	SPY	ETF	106.17	106.37	106.08	106.28	7010920.0
2009-09-28 15:30:00	SPY	ETF	106.27	106.33	106.01	106.31	14757959.0
2009-09-28 16:00:00	SPY	ETF	106.31	106.44	105.16	106.37	5095855.0
2009-09-28 16:30:00	SPY	ETF	106.37	106.45	106.36	106.42	566060.0
2009-09-28 17:00:00	SPY	ETF	106.4	106.46	106.345	106.4	213810.0
2009-09-28 17:30:00	SPY	ETF	106.37	106.41	106.37	106.41	14059.0
2009-09-28 18:00:00	SPY	ETF	106.38	106.43	106.38	106.41	10576.0
2009-09-28 18:30:00	SPY	ETF	106.4	106.44	106.39	106.44	10491.0
2009-09-28 19:00:00	SPY	ETF	106.12	106.53	106.12	106.52	82988.0
2009-09-28 19:30:00	SPY	ETF	106.52	106.53	106.44	106.44	18118.0
2009-09-28 20:00:00	SPY	ETF	106.48	106.48	106.48	106.48	500.0
2009-09-28 04:00:00	QQQ	ETF	41.7	41.7	41.7	41.7	200.0
2009-09-28 04:30:00	QQQ	ETF	41.76	41.84	41.76	41.84	300.0
2009-09-28 05:30:00	QQQ	ETF	41.81	41.81	41.81	41.81	200.0
2009-09-28 06:00:00	QQQ	ETF	41.79	41.87	41.79	41.87	1000.0
2009-09-28 06:30:00	QQQ	ETF	41.88	41.9	41.87	41.87	7500.0
2009-09-28 07:00:00	QQQ	ETF	41.9	41.95	41.9	41.95	54531.0
2009-09-28 07:30:00	QQQ	ETF	41.94	41.97	41.91	41.91	106800.0
2009-09-28 08:00:00	QQQ	ETF	41.92	42.0	41.77	42.0	197935.0
2009-09-28 08:30:00	QQQ	ETF	42.0	42.06	41.95	41.95	393175.0
2009-09-28 09:00:00	QQQ	ETF	41.95	42.0	41.92	41.92	438067.0
2009-09-28 09:30:00	QQQ	ETF	41.92	42.31	41.89	42.25	17242679.0
2009-09-28 10:00:00	QQQ	ETF	42.26	42.45	42.26	42.4378	7525173.0
2009-09-28 10:30:00	QQQ	ETF	42.43	42.53	42.43	42.49	5007965.0
2009-09-28 11:00:00	QQQ	ETF	42.49	42.56	42.46	42.52	3863408.0
2009-09-28 11:30:00	QQQ	ETF	42.52	42.62	42.51	42.58	3516060.0
2009-09-28 12:00:00	QQQ	ETF	42.58	42.66	42.56	42.59	2380242.0
2009-09-28 12:30:00	QQQ	ETF	42.59	42.62	42.53	42.54	1882955.0
2009-09-28 13:00:00	QQQ	ETF	42.55	42.59	42.53	42.59	2917276.0

> showing 50 of 7,451 rows — these rows as CSV

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