PREVIEW / etf_30min / 2009-08-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-27.parquet
  size:    232 KB
  rows:    7,448

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-08-27 04:00:00	SPY	ETF	103.3	103.33	103.3	103.33	600.0
2009-08-27 04:30:00	SPY	ETF	103.25	103.25	103.25	103.25	500.0
2009-08-27 05:00:00	SPY	ETF	103.2	103.25	103.2	103.25	5300.0
2009-08-27 06:00:00	SPY	ETF	103.22	103.22	103.22	103.22	2000.0
2009-08-27 06:30:00	SPY	ETF	103.2	103.2	102.92	102.98	4500.0
2009-08-27 07:00:00	SPY	ETF	102.99	103.15	102.96	103.15	221384.0
2009-08-27 07:30:00	SPY	ETF	103.17	103.21	103.1	103.12	385339.0
2009-08-27 08:00:00	SPY	ETF	103.12	103.46	103.12	103.41	1701295.0
2009-08-27 08:30:00	SPY	ETF	103.43	103.55	102.99	103.22	4368068.0
2009-08-27 09:00:00	SPY	ETF	103.21	103.27	103.06	103.11	1317596.0
2009-08-27 09:30:00	SPY	ETF	103.11	103.15	102.24	102.25	25970055.0
2009-08-27 10:00:00	SPY	ETF	102.24	102.28	101.94	102.24	27151268.0
2009-08-27 10:30:00	SPY	ETF	102.2401	102.34	102.04	102.08	9740522.0
2009-08-27 11:00:00	SPY	ETF	102.075	102.4	102.0	102.39	8041777.0
2009-08-27 11:30:00	SPY	ETF	102.39	102.59	102.18	102.57	6754654.0
2009-08-27 12:00:00	SPY	ETF	102.57	102.84	102.53	102.83	7619402.0
2009-08-27 12:30:00	SPY	ETF	102.83	102.91	102.55	102.81	9247029.0
2009-08-27 13:00:00	SPY	ETF	102.8	103.17	102.62	102.72	6238382.0
2009-08-27 13:30:00	SPY	ETF	102.72	103.21	102.72	103.09	14262088.0
2009-08-27 14:00:00	SPY	ETF	103.085	103.33	103.085	103.25	9520747.0
2009-08-27 14:30:00	SPY	ETF	103.25	103.72	103.25	103.53	16983673.0
2009-08-27 15:00:00	SPY	ETF	103.53	103.61	103.31	103.33	13963417.0
2009-08-27 15:30:00	SPY	ETF	103.34	103.54	103.3199	103.45	18966561.0
2009-08-27 16:00:00	SPY	ETF	103.45	103.713	102.06	103.41	7592215.0
2009-08-27 16:30:00	SPY	ETF	103.4	103.44	102.7722	103.44	136974.0
2009-08-27 17:00:00	SPY	ETF	103.44	103.47	103.1716	103.45	2166673.0
2009-08-27 17:30:00	SPY	ETF	103.45	103.51	103.38	103.5	139064.0
2009-08-27 18:00:00	SPY	ETF	103.45	103.5	103.42	103.48	97107.0
2009-08-27 18:30:00	SPY	ETF	103.46	103.47	103.42	103.45	25100.0
2009-08-27 19:00:00	SPY	ETF	103.43	103.45	103.39	103.4	49778.0
2009-08-27 19:30:00	SPY	ETF	103.4	103.48	103.35	103.45	138790.0
2009-08-27 05:00:00	QQQ	ETF	40.31	40.31	40.31	40.31	5000.0
2009-08-27 06:30:00	QQQ	ETF	40.19	40.2	40.19	40.2	5000.0
2009-08-27 07:00:00	QQQ	ETF	40.21	40.28	40.21	40.28	2200.0
2009-08-27 07:30:00	QQQ	ETF	40.3	40.32	40.3	40.3	17600.0
2009-08-27 08:00:00	QQQ	ETF	40.3	40.42	40.3	40.39	117961.0
2009-08-27 08:30:00	QQQ	ETF	40.39	40.41	40.26	40.32	281003.0
2009-08-27 09:00:00	QQQ	ETF	40.33	40.34	40.26	40.31	271198.0
2009-08-27 09:30:00	QQQ	ETF	40.32	40.32	39.85	39.86	10671800.0
2009-08-27 10:00:00	QQQ	ETF	39.86	39.86	39.67	39.81	15250355.0
2009-08-27 10:30:00	QQQ	ETF	39.82	39.88	39.75	39.77	6793384.0
2009-08-27 11:00:00	QQQ	ETF	39.76	39.92	39.72	39.9	3586065.0
2009-08-27 11:30:00	QQQ	ETF	39.9	39.95	39.8	39.94	3824508.0
2009-08-27 12:00:00	QQQ	ETF	39.94	40.05	39.93	40.0406	3675213.0
2009-08-27 12:30:00	QQQ	ETF	40.05	40.06	39.96	40.01	6790270.0
2009-08-27 13:00:00	QQQ	ETF	40.01	40.05	39.93	39.96	3164019.0
2009-08-27 13:30:00	QQQ	ETF	39.96	40.27	39.96	40.23	6916665.0
2009-08-27 14:00:00	QQQ	ETF	40.24	40.39	40.23	40.34	10220871.0
2009-08-27 14:30:00	QQQ	ETF	40.34	40.47	40.3	40.34	7533148.0
2009-08-27 15:00:00	QQQ	ETF	40.34	40.39	40.26	40.28	5074648.0

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

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