PREVIEW / etf_30min / 2007-06-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-04.parquet
  size:    110 KB
  rows:    4,313

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
2007-06-04 05:00:00	SPY	ETF	153.78	153.78	153.76	153.76	2000.0
2007-06-04 05:30:00	SPY	ETF	153.75	153.76	153.75	153.76	2000.0
2007-06-04 06:00:00	SPY	ETF	153.68	153.68	153.68	153.68	1000.0
2007-06-04 06:30:00	SPY	ETF	153.76	153.79	153.67	153.67	11500.0
2007-06-04 07:00:00	SPY	ETF	153.63	153.74	153.63	153.7	198800.0
2007-06-04 07:30:00	SPY	ETF	153.7	153.74	153.64	153.74	145100.0
2007-06-04 08:00:00	SPY	ETF	153.64	153.75	153.64	153.72	496900.0
2007-06-04 08:30:00	SPY	ETF	153.71	153.71	153.47	153.54	1650400.0
2007-06-04 09:00:00	SPY	ETF	153.56	153.61	153.47	153.54	525800.0
2007-06-04 09:30:00	SPY	ETF	153.54	153.94	153.48	153.78	10672081.0
2007-06-04 10:00:00	SPY	ETF	153.79	153.99	153.7	153.92	6575261.0
2007-06-04 10:30:00	SPY	ETF	153.92	153.96	153.62	153.79	6716353.0
2007-06-04 11:00:00	SPY	ETF	153.79	153.971	153.64	153.91	4184498.0
2007-06-04 11:30:00	SPY	ETF	153.91	154.02	153.87	153.93	4616568.0
2007-06-04 12:00:00	SPY	ETF	153.93	154.07	153.86	154.04	3270500.0
2007-06-04 12:30:00	SPY	ETF	154.03	154.13	153.97	154.05	3671800.0
2007-06-04 13:00:00	SPY	ETF	154.04	154.05	153.84	153.94	3195400.0
2007-06-04 13:30:00	SPY	ETF	153.95	154.0	153.86	153.94	1890573.0
2007-06-04 14:00:00	SPY	ETF	153.94	154.09	153.91	153.95	3470978.0
2007-06-04 14:30:00	SPY	ETF	153.95	154.08	153.8	153.97	5333734.0
2007-06-04 15:00:00	SPY	ETF	153.97	154.33	153.96	154.25	6894330.0
2007-06-04 15:30:00	SPY	ETF	154.25	154.39	154.19	154.24	8005286.0
2007-06-04 16:00:00	SPY	ETF	154.23	154.3254	154.08	154.17	3133300.0
2007-06-04 16:30:00	SPY	ETF	154.17	154.3	154.06	154.09	1213900.0
2007-06-04 17:00:00	SPY	ETF	154.05	154.07	154.02	154.02	105100.0
2007-06-04 17:30:00	SPY	ETF	154.08	154.08	154.02	154.04	28500.0
2007-06-04 18:00:00	SPY	ETF	154.03	154.03	153.99	154.01	10200.0
2007-06-04 18:30:00	SPY	ETF	154.02	154.05	154.01	154.05	11900.0
2007-06-04 19:00:00	SPY	ETF	154.01	154.08	154.01	154.08	17900.0
2007-06-04 19:30:00	SPY	ETF	154.08	154.08	154.08	154.08	500.0
2007-06-04 07:00:00	QQQ	ETF	47.35	47.38	47.33	47.33	46700.0
2007-06-04 07:30:00	QQQ	ETF	47.34	47.36	47.32	47.36	85215.0
2007-06-04 08:00:00	QQQ	ETF	47.33	47.35	47.28	47.3	193218.0
2007-06-04 08:30:00	QQQ	ETF	47.3	47.3	47.21	47.27	854235.0
2007-06-04 09:00:00	QQQ	ETF	47.27	47.29	47.26	47.27	677600.0
2007-06-04 09:30:00	QQQ	ETF	47.27	47.47	47.24	47.395	10881777.0
2007-06-04 10:00:00	QQQ	ETF	47.4	47.56	47.37	47.52	8013009.0
2007-06-04 10:30:00	QQQ	ETF	47.52	47.54	47.32	47.417	8277913.0
2007-06-04 11:00:00	QQQ	ETF	47.41	47.49	47.389	47.48	2548756.0
2007-06-04 11:30:00	QQQ	ETF	47.48	47.5	47.43	47.4615	2268701.0
2007-06-04 12:00:00	QQQ	ETF	47.47	47.5	47.42	47.4701	2545373.0
2007-06-04 12:30:00	QQQ	ETF	47.47	47.55	47.46	47.49	3760014.0
2007-06-04 13:00:00	QQQ	ETF	47.49	47.51	47.39	47.45	2851304.0
2007-06-04 13:30:00	QQQ	ETF	47.45	47.47	47.41	47.44	1894292.0
2007-06-04 14:00:00	QQQ	ETF	47.44	47.49	47.42	47.46	2738767.0
2007-06-04 14:30:00	QQQ	ETF	47.46	47.5	47.41	47.48	3901368.0
2007-06-04 15:00:00	QQQ	ETF	47.48	47.6	47.48	47.59	3672649.0
2007-06-04 15:30:00	QQQ	ETF	47.58	47.64	47.56	47.58	6174033.0
2007-06-04 16:00:00	QQQ	ETF	47.57	47.62	47.54	47.57	2017603.0
2007-06-04 16:30:00	QQQ	ETF	47.57	47.57	47.54	47.55	500335.0

> showing 50 of 4,313 rows — these rows as CSV

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