PREVIEW / etf_30min / 2009-10-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-28.parquet
  size:    249 KB
  rows:    8,103

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-10-28 04:00:00	SPY	ETF	106.25	106.34	106.25	106.34	400.0
2009-10-28 04:30:00	SPY	ETF	106.3	106.3	105.99	105.99	6422.0
2009-10-28 05:00:00	SPY	ETF	106.12	106.15	106.04	106.15	1058.0
2009-10-28 06:00:00	SPY	ETF	106.1	106.1	105.77	105.8	20200.0
2009-10-28 06:30:00	SPY	ETF	105.82	105.97	105.79	105.97	17949.0
2009-10-28 07:00:00	SPY	ETF	105.96	106.05	105.85	105.86	128823.0
2009-10-28 07:30:00	SPY	ETF	105.84	106.06	105.8	106.06	315591.0
2009-10-28 08:00:00	SPY	ETF	106.06	106.14	105.96	106.04	716021.0
2009-10-28 08:30:00	SPY	ETF	106.08	106.4	105.86	106.1342	1898062.0
2009-10-28 09:00:00	SPY	ETF	106.16	106.22	105.85	106.15	2394496.0
2009-10-28 09:30:00	SPY	ETF	106.15	106.4783	105.86	105.99	26957632.0
2009-10-28 10:00:00	SPY	ETF	105.99	106.11	105.58	105.79	24399911.0
2009-10-28 10:30:00	SPY	ETF	105.79	105.95	105.15	105.48	25325417.0
2009-10-28 11:00:00	SPY	ETF	105.47	105.74	105.28	105.64	16370492.0
2009-10-28 11:30:00	SPY	ETF	105.64	105.67	105.3	105.41	9405611.0
2009-10-28 12:00:00	SPY	ETF	105.4	105.58	105.1	105.3	11416137.0
2009-10-28 12:30:00	SPY	ETF	105.3	105.34	104.84	105.03	17203440.0
2009-10-28 13:00:00	SPY	ETF	105.04	105.63	104.95	105.29	15115108.0
2009-10-28 13:30:00	SPY	ETF	105.3	105.5	105.17	105.21	7386963.0
2009-10-28 14:00:00	SPY	ETF	105.21	105.28	104.81	104.91	12347022.0
2009-10-28 14:30:00	SPY	ETF	104.91	105.07	104.74	104.83	14946340.0
2009-10-28 15:00:00	SPY	ETF	104.83	105.01	104.56	104.71	15508763.0
2009-10-28 15:30:00	SPY	ETF	104.71	104.77	104.35	104.42	32457139.0
2009-10-28 16:00:00	SPY	ETF	104.42	106.2282	104.27	104.34	7574636.0
2009-10-28 16:30:00	SPY	ETF	104.34	106.4798	104.25	104.26	2007978.0
2009-10-28 17:00:00	SPY	ETF	104.29	104.36	104.25	104.33	726203.0
2009-10-28 17:30:00	SPY	ETF	104.31	106.4798	104.26	104.28	1089910.0
2009-10-28 18:00:00	SPY	ETF	104.32	104.37	104.2	104.25	166490.0
2009-10-28 18:30:00	SPY	ETF	104.25	104.26	104.2	104.26	60599.0
2009-10-28 19:00:00	SPY	ETF	104.27	104.35	104.25	104.33	23650.0
2009-10-28 19:30:00	SPY	ETF	104.3	104.34	104.22	104.3	39335.0
2009-10-28 04:00:00	QQQ	ETF	42.25	42.25	42.25	42.25	200.0
2009-10-28 04:30:00	QQQ	ETF	42.32	42.32	42.23	42.23	10300.0
2009-10-28 05:00:00	QQQ	ETF	42.23	42.23	42.23	42.23	100.0
2009-10-28 05:30:00	QQQ	ETF	42.23	42.26	42.23	42.26	400.0
2009-10-28 06:00:00	QQQ	ETF	42.24	42.24	42.16	42.16	750.0
2009-10-28 06:30:00	QQQ	ETF	42.19	42.25	42.19	42.25	1100.0
2009-10-28 07:00:00	QQQ	ETF	42.24	42.28	42.23	42.23	5400.0
2009-10-28 07:30:00	QQQ	ETF	42.19	42.28	42.19	42.27	12800.0
2009-10-28 08:00:00	QQQ	ETF	42.28	42.29	42.24	42.26	93746.0
2009-10-28 08:30:00	QQQ	ETF	42.27	42.34	42.18	42.31	362712.0
2009-10-28 09:00:00	QQQ	ETF	42.32	42.32	41.56	42.19	5139251.0
2009-10-28 09:30:00	QQQ	ETF	42.19	42.32	42.04	42.17	15951518.0
2009-10-28 10:00:00	QQQ	ETF	42.18	42.22	42.0	42.05	13608982.0
2009-10-28 10:30:00	QQQ	ETF	42.05	42.145	41.7	41.85	17602103.0
2009-10-28 11:00:00	QQQ	ETF	41.85	41.95	41.75	41.89	8429800.0
2009-10-28 11:30:00	QQQ	ETF	41.9	41.92	41.8	41.825	4240545.0
2009-10-28 12:00:00	QQQ	ETF	41.82	41.89	41.64	41.702	4603188.0
2009-10-28 12:30:00	QQQ	ETF	41.71	41.735	41.54	41.6	9023081.0
2009-10-28 13:00:00	QQQ	ETF	41.605	41.85	41.56	41.75	7240740.0

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

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