PREVIEW / etf_30min / 2007-07-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-24.parquet
  size:    130 KB
  rows:    4,837

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-07-24 06:00:00	SPY	ETF	153.97	153.98	153.87	153.89	24400.0
2007-07-24 06:30:00	SPY	ETF	153.92	153.92	153.77	153.82	26500.0
2007-07-24 07:00:00	SPY	ETF	153.89	153.89	153.58	153.72	337800.0
2007-07-24 07:30:00	SPY	ETF	153.73	153.85	153.67	153.71	82900.0
2007-07-24 08:00:00	SPY	ETF	153.7	153.71	153.47	153.53	2552600.0
2007-07-24 08:30:00	SPY	ETF	153.53	153.53	153.15	153.19	4107500.0
2007-07-24 09:00:00	SPY	ETF	153.2	153.26	153.02	153.11	4384222.0
2007-07-24 09:30:00	SPY	ETF	153.12	153.24	152.67	152.98	21241119.0
2007-07-24 10:00:00	SPY	ETF	152.98	153.12	152.57	153.03	21270791.0
2007-07-24 10:30:00	SPY	ETF	153.03	154.28	152.85	153.44	16452187.0
2007-07-24 11:00:00	SPY	ETF	153.43	153.45	152.94	153.03	9485745.0
2007-07-24 11:30:00	SPY	ETF	153.03	153.06	152.68	153.05	11848343.0
2007-07-24 12:00:00	SPY	ETF	153.05	153.32	152.69	153.24	8686897.0
2007-07-24 12:30:00	SPY	ETF	153.25	153.5	153.09	153.18	11303043.0
2007-07-24 13:00:00	SPY	ETF	153.18	153.37	152.87	152.91	7968631.0
2007-07-24 13:30:00	SPY	ETF	152.91	153.14	152.5	152.68	15566742.0
2007-07-24 14:00:00	SPY	ETF	152.68	152.7	152.25	152.4899	17277905.0
2007-07-24 14:30:00	SPY	ETF	152.489	152.52	152.0	152.02	19634365.0
2007-07-24 15:00:00	SPY	ETF	152.02	152.08	151.28	151.33	30247682.0
2007-07-24 15:30:00	SPY	ETF	151.33	151.87	150.76	151.12	35144334.0
2007-07-24 16:00:00	SPY	ETF	151.12	151.55	150.9	151.38	9062100.0
2007-07-24 16:30:00	SPY	ETF	151.39	151.47	151.3	151.47	241500.0
2007-07-24 17:00:00	SPY	ETF	151.47	151.48	151.21	151.26	1381600.0
2007-07-24 17:30:00	SPY	ETF	151.22	151.42	151.06	151.28	190400.0
2007-07-24 18:00:00	SPY	ETF	151.3	151.35	151.29	151.34	50000.0
2007-07-24 18:30:00	SPY	ETF	151.34	151.38	151.31	151.33	4800.0
2007-07-24 19:00:00	SPY	ETF	151.33	151.35	151.29	151.29	17700.0
2007-07-24 19:30:00	SPY	ETF	151.29	151.33	151.26	151.31	29800.0
2007-07-24 04:00:00	QQQ	ETF	50.08	50.08	50.08	50.08	500.0
2007-07-24 06:00:00	QQQ	ETF	49.98	49.98	49.98	49.98	10000.0
2007-07-24 06:30:00	QQQ	ETF	49.94	49.94	49.93	49.93	310000.0
2007-07-24 07:00:00	QQQ	ETF	49.9	49.92	49.9	49.9	154500.0
2007-07-24 07:30:00	QQQ	ETF	49.91	49.93	49.86	49.9	384324.0
2007-07-24 08:00:00	QQQ	ETF	49.89	49.91	49.84	49.85	675322.0
2007-07-24 08:30:00	QQQ	ETF	49.87	49.87	49.75	49.75	590700.0
2007-07-24 09:00:00	QQQ	ETF	49.75	49.76	49.65	49.7	2174013.0
2007-07-24 09:30:00	QQQ	ETF	49.71	49.79	49.62	49.74	17554531.0
2007-07-24 10:00:00	QQQ	ETF	49.75	49.8	49.6	49.77	13339875.0
2007-07-24 10:30:00	QQQ	ETF	49.76	49.96	49.7	49.94	10499585.0
2007-07-24 11:00:00	QQQ	ETF	49.94	49.96	49.8	49.83	8058545.0
2007-07-24 11:30:00	QQQ	ETF	49.83	49.88	49.75	49.88	5542845.0
2007-07-24 12:00:00	QQQ	ETF	49.88	50.02	49.81	50.0	8143355.0
2007-07-24 12:30:00	QQQ	ETF	50.01	50.1	49.97	50.0	12004349.0
2007-07-24 13:00:00	QQQ	ETF	50.01	50.05	49.92	49.96	5866538.0
2007-07-24 13:30:00	QQQ	ETF	49.95	50.03	49.81	49.842	6736058.0
2007-07-24 14:00:00	QQQ	ETF	49.85	49.86	49.7	49.77	11560500.0
2007-07-24 14:30:00	QQQ	ETF	49.76	49.77	49.49	49.51	12290996.0
2007-07-24 15:00:00	QQQ	ETF	49.51	49.51	49.17	49.18	16757257.0
2007-07-24 15:30:00	QQQ	ETF	49.19	49.26	49.05	49.22	24393557.0
2007-07-24 16:00:00	QQQ	ETF	49.22	49.49	49.19	49.43	4244108.0

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

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