PREVIEW / etf_30min / 2007-06-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-15.parquet
  size:    115 KB
  rows:    4,458

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-15 06:00:00	SPY	ETF	152.29	152.37	152.29	152.37	27500.0
2007-06-15 06:30:00	SPY	ETF	152.26	152.3	152.26	152.29	7900.0
2007-06-15 07:00:00	SPY	ETF	152.24	152.4	152.24	152.37	230400.0
2007-06-15 07:30:00	SPY	ETF	152.38	152.51	152.38	152.44	508500.0
2007-06-15 08:00:00	SPY	ETF	152.44	152.6	152.3	152.54	936800.0
2007-06-15 08:30:00	SPY	ETF	152.54	153.3	152.39	153.19	10177000.0
2007-06-15 09:00:00	SPY	ETF	153.19	153.28	153.12	153.25	2501700.0
2007-06-15 09:30:00	SPY	ETF	153.24	153.44	153.17	153.24	21914045.0
2007-06-15 10:00:00	SPY	ETF	153.24	153.4	153.02	153.34	12438814.0
2007-06-15 10:30:00	SPY	ETF	153.34	153.66	153.27	153.53	11534592.0
2007-06-15 11:00:00	SPY	ETF	153.53	153.58	153.26	153.27	9017400.0
2007-06-15 11:30:00	SPY	ETF	153.26	153.45	153.2	153.31	5225300.0
2007-06-15 12:00:00	SPY	ETF	153.31	153.46	153.13	153.15	6050300.0
2007-06-15 12:30:00	SPY	ETF	153.18	153.27	153.07	153.14	5584910.0
2007-06-15 13:00:00	SPY	ETF	153.15	153.19	152.96	153.13	8486099.0
2007-06-15 13:30:00	SPY	ETF	153.125	153.34	153.06	153.22	7955489.0
2007-06-15 14:00:00	SPY	ETF	153.21	153.24	152.93	153.08	4193794.0
2007-06-15 14:30:00	SPY	ETF	153.08	153.26	152.98	153.26	6400600.0
2007-06-15 15:00:00	SPY	ETF	153.25	153.33	153.14	153.165	6223672.0
2007-06-15 15:30:00	SPY	ETF	153.165	153.22	153.0	153.04	12054353.0
2007-06-15 16:00:00	SPY	ETF	153.06	153.14	152.99	153.03	8679400.0
2007-06-15 16:30:00	SPY	ETF	153.04	153.05	152.064	153.05	4630100.0
2007-06-15 17:00:00	SPY	ETF	153.05	153.09	153.04	153.09	21100.0
2007-06-15 17:30:00	SPY	ETF	153.08	153.12	153.05	153.12	382100.0
2007-06-15 18:00:00	SPY	ETF	153.05	153.05	153.05	153.05	3000.0
2007-06-15 18:30:00	SPY	ETF	153.07	153.07	153.07	153.07	500.0
2007-06-15 19:00:00	SPY	ETF	153.05	153.05	153.01	153.01	4200.0
2007-06-15 19:30:00	SPY	ETF	153.01	153.01	152.97	153.0	12500.0
2007-06-15 06:30:00	QQQ	ETF	47.35	47.36	47.35	47.36	3900.0
2007-06-15 07:00:00	QQQ	ETF	47.36	47.42	47.36	47.4	66306.0
2007-06-15 07:30:00	QQQ	ETF	47.38	47.46	47.38	47.44	478120.0
2007-06-15 08:00:00	QQQ	ETF	47.44	47.52	47.39	47.51	1007414.0
2007-06-15 08:30:00	QQQ	ETF	47.53	47.69	47.51	47.68	5695382.0
2007-06-15 09:00:00	QQQ	ETF	47.67	47.76	47.66	47.75	2645979.0
2007-06-15 09:30:00	QQQ	ETF	47.76	47.87	47.67	47.71	21495394.0
2007-06-15 10:00:00	QQQ	ETF	47.71	47.75	47.65	47.73	9103991.0
2007-06-15 10:30:00	QQQ	ETF	47.7315	47.82	47.73	47.79	10433011.0
2007-06-15 11:00:00	QQQ	ETF	47.79	47.83	47.71	47.71	5176039.0
2007-06-15 11:30:00	QQQ	ETF	47.71	47.78	47.71	47.74	4186982.0
2007-06-15 12:00:00	QQQ	ETF	47.75	47.75	47.67	47.68	3095553.0
2007-06-15 12:30:00	QQQ	ETF	47.67	47.73	47.67	47.7	2958353.0
2007-06-15 13:00:00	QQQ	ETF	47.7	47.71	47.65	47.7	3973577.0
2007-06-15 13:30:00	QQQ	ETF	47.6978	47.77	47.68	47.76	4387082.0
2007-06-15 14:00:00	QQQ	ETF	47.76	47.76	47.66	47.6815	2491964.0
2007-06-15 14:30:00	QQQ	ETF	47.68	47.74	47.66	47.74	4365760.0
2007-06-15 15:00:00	QQQ	ETF	47.75	47.75	47.7	47.72	5254217.0
2007-06-15 15:30:00	QQQ	ETF	47.72	47.76	47.69	47.76	6780379.0
2007-06-15 16:00:00	QQQ	ETF	47.769	47.79	47.73	47.76	1167269.0
2007-06-15 16:30:00	QQQ	ETF	47.76	47.78	47.74	47.77	262325.0
2007-06-15 17:00:00	QQQ	ETF	47.76	47.77	47.76	47.76	23102.0

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

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