PREVIEW / etf_30min / 2007-07-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-18.parquet
  size:    124 KB
  rows:    4,659

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-18 05:00:00	SPY	ETF	154.04	154.05	154.04	154.05	20000.0
2007-07-18 06:00:00	SPY	ETF	154.16	154.21	154.05	154.1	416900.0
2007-07-18 06:30:00	SPY	ETF	154.1	154.16	154.05	154.16	43000.0
2007-07-18 07:00:00	SPY	ETF	154.23	154.41	154.17	154.41	620500.0
2007-07-18 07:30:00	SPY	ETF	154.4	154.45	154.16	154.22	591700.0
2007-07-18 08:00:00	SPY	ETF	154.18	154.3	153.96	154.11	2166500.0
2007-07-18 08:30:00	SPY	ETF	154.11	154.26	153.85	154.18	2479700.0
2007-07-18 09:00:00	SPY	ETF	154.18	154.31	154.12	154.31	1424000.0
2007-07-18 09:30:00	SPY	ETF	154.31	154.73	154.08	154.49	28244828.0
2007-07-18 10:00:00	SPY	ETF	154.48	154.78	154.01	154.32	22610436.0
2007-07-18 10:30:00	SPY	ETF	154.33	154.35	153.5	153.96	26273478.0
2007-07-18 11:00:00	SPY	ETF	153.95	154.33	153.87	153.96	12308870.0
2007-07-18 11:30:00	SPY	ETF	153.97	154.01	153.5	153.74	16616612.0
2007-07-18 12:00:00	SPY	ETF	153.75	153.89	153.3	153.56	13915161.0
2007-07-18 12:30:00	SPY	ETF	153.5674	153.97	153.41	153.79	9417412.0
2007-07-18 13:00:00	SPY	ETF	153.8	153.86	153.5	153.68	9285721.0
2007-07-18 13:30:00	SPY	ETF	153.69	154.19	153.64	153.85	15753514.0
2007-07-18 14:00:00	SPY	ETF	153.85	154.03	153.51	153.63	8774761.0
2007-07-18 14:30:00	SPY	ETF	153.62	153.9	153.5	153.78	13134203.0
2007-07-18 15:00:00	SPY	ETF	153.78	153.97	153.62	153.83	11127068.0
2007-07-18 15:30:00	SPY	ETF	153.83	154.8	153.76	154.59	25123990.0
2007-07-18 16:00:00	SPY	ETF	154.58	154.62	154.36	154.57	5721300.0
2007-07-18 16:30:00	SPY	ETF	154.6	154.67	154.57	154.6	788400.0
2007-07-18 17:00:00	SPY	ETF	154.65	154.84	154.65	154.73	107600.0
2007-07-18 17:30:00	SPY	ETF	154.71	154.9	154.66	154.74	24800.0
2007-07-18 18:00:00	SPY	ETF	154.74	154.87	153.72	154.53	5479900.0
2007-07-18 18:30:00	SPY	ETF	154.54	154.85	154.08	154.75	178600.0
2007-07-18 19:00:00	SPY	ETF	154.78	154.78	154.66	154.66	104300.0
2007-07-18 19:30:00	SPY	ETF	154.65	154.65	154.6	154.62	25300.0
2007-07-18 04:30:00	QQQ	ETF	49.88	49.88	49.88	49.88	300.0
2007-07-18 06:30:00	QQQ	ETF	49.94	49.96	49.94	49.96	30200.0
2007-07-18 07:00:00	QQQ	ETF	49.97	49.98	49.93	49.98	530512.0
2007-07-18 07:30:00	QQQ	ETF	49.97	50.0	49.85	49.87	598054.0
2007-07-18 08:00:00	QQQ	ETF	49.87	49.93	49.79	49.88	1789366.0
2007-07-18 08:30:00	QQQ	ETF	49.87	49.98	49.85	49.91	2386683.0
2007-07-18 09:00:00	QQQ	ETF	49.92	49.96	49.87	49.94	1565559.0
2007-07-18 09:30:00	QQQ	ETF	49.94	50.02	48.93	49.96	16764319.0
2007-07-18 10:00:00	QQQ	ETF	49.97	50.03	49.82	49.9615	13996702.0
2007-07-18 10:30:00	QQQ	ETF	49.97	49.97	49.76	49.842	12581456.0
2007-07-18 11:00:00	QQQ	ETF	49.8401	49.94	49.84	49.89	9118484.0
2007-07-18 11:30:00	QQQ	ETF	49.88	49.89	49.76	49.78	9064877.0
2007-07-18 12:00:00	QQQ	ETF	49.77	49.82	49.64	49.74	10562393.0
2007-07-18 12:30:00	QQQ	ETF	49.73	49.85	49.7	49.78	6738929.0
2007-07-18 13:00:00	QQQ	ETF	49.77	49.83	49.7	49.7981	3999270.0
2007-07-18 13:30:00	QQQ	ETF	49.8	49.92	49.79	49.85	9001048.0
2007-07-18 14:00:00	QQQ	ETF	49.86	49.92	49.7989	49.8189	4373205.0
2007-07-18 14:30:00	QQQ	ETF	49.81	49.88	49.74	49.83	5161886.0
2007-07-18 15:00:00	QQQ	ETF	49.83	49.86	49.76	49.81	6515069.0
2007-07-18 15:30:00	QQQ	ETF	49.8189	50.13	49.79	50.12	19207911.0
2007-07-18 16:00:00	QQQ	ETF	50.12	50.25	50.07	50.17	1405408.0

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

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