PREVIEW / etf_30min / 2007-10-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-08.parquet
  size:    120 KB
  rows:    4,677

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-10-08 05:30:00	SPY	ETF	155.39	155.44	155.39	155.44	1500.0
2007-10-08 06:00:00	SPY	ETF	155.44	155.44	155.37	155.44	24000.0
2007-10-08 06:30:00	SPY	ETF	155.42	155.42	155.42	155.42	1500.0
2007-10-08 07:00:00	SPY	ETF	155.39	155.39	155.26	155.29	128400.0
2007-10-08 07:30:00	SPY	ETF	155.3	155.54	155.29	155.49	322200.0
2007-10-08 08:00:00	SPY	ETF	155.44	155.47	155.34	155.39	947900.0
2007-10-08 08:30:00	SPY	ETF	155.41	155.46	155.36	155.4	147800.0
2007-10-08 09:00:00	SPY	ETF	155.4	155.46	155.34	155.36	503483.0
2007-10-08 09:30:00	SPY	ETF	155.39	155.43	155.16	155.29	10489533.0
2007-10-08 10:00:00	SPY	ETF	155.3	155.49	155.21	155.22	7588600.0
2007-10-08 10:30:00	SPY	ETF	155.22	155.33	155.19	155.23	2750600.0
2007-10-08 11:00:00	SPY	ETF	155.23	155.23	154.93	154.96	7690900.0
2007-10-08 11:30:00	SPY	ETF	154.97	154.98	154.81	154.95	4248700.0
2007-10-08 12:00:00	SPY	ETF	154.95	155.02	154.8	154.91	3905100.0
2007-10-08 12:30:00	SPY	ETF	154.91	155.06	154.86	155.03	2714300.0
2007-10-08 13:00:00	SPY	ETF	155.03	155.03	154.94	155.02	3348100.0
2007-10-08 13:30:00	SPY	ETF	155.02	155.11	154.8	154.88	4430700.0
2007-10-08 14:00:00	SPY	ETF	154.87	155.05	154.77	155.04	3354800.0
2007-10-08 14:30:00	SPY	ETF	155.03	155.12	154.85	154.92	3748800.0
2007-10-08 15:00:00	SPY	ETF	154.92	155.08	154.89	155.0	3571700.0
2007-10-08 15:30:00	SPY	ETF	155.0	155.2	154.93	155.19	6871400.0
2007-10-08 16:00:00	SPY	ETF	155.18	155.21	155.0	155.07	3225600.0
2007-10-08 16:30:00	SPY	ETF	155.07	155.31	155.04	155.1264	108400.0
2007-10-08 17:00:00	SPY	ETF	155.14	155.17	155.12	155.14	11900.0
2007-10-08 17:30:00	SPY	ETF	155.12	155.2	155.12	155.2	25700.0
2007-10-08 18:00:00	SPY	ETF	155.2	155.26	155.19	155.25	87300.0
2007-10-08 18:30:00	SPY	ETF	155.19	155.24	155.19	155.19	6900.0
2007-10-08 19:00:00	SPY	ETF	155.23	155.23	155.23	155.23	100.0
2007-10-08 19:30:00	SPY	ETF	155.23	155.24	155.22	155.22	3300.0
2007-10-08 05:00:00	QQQ	ETF	52.82	52.82	52.82	52.82	500.0
2007-10-08 06:00:00	QQQ	ETF	52.75	52.75	52.75	52.75	10015.0
2007-10-08 06:30:00	QQQ	ETF	52.77	52.77	52.77	52.77	200.0
2007-10-08 07:00:00	QQQ	ETF	52.73	52.74	52.69	52.72	43344.0
2007-10-08 07:30:00	QQQ	ETF	52.72	52.76	52.71	52.75	224611.0
2007-10-08 08:00:00	QQQ	ETF	52.75	52.75	52.71	52.72	909087.0
2007-10-08 08:30:00	QQQ	ETF	52.73	52.8	52.73	52.78	255634.0
2007-10-08 09:00:00	QQQ	ETF	52.78	52.8	52.76	52.79	196751.0
2007-10-08 09:30:00	QQQ	ETF	52.8	52.93	52.73	52.9	6203331.0
2007-10-08 10:00:00	QQQ	ETF	52.91	52.99	52.9	52.9099	5784520.0
2007-10-08 10:30:00	QQQ	ETF	52.91	52.96	52.87	52.879	2378219.0
2007-10-08 11:00:00	QQQ	ETF	52.8799	52.88	52.73	52.78	3829929.0
2007-10-08 11:30:00	QQQ	ETF	52.77	52.8	52.71	52.8	2456182.0
2007-10-08 12:00:00	QQQ	ETF	52.79	52.82	52.71	52.77	1854085.0
2007-10-08 12:30:00	QQQ	ETF	52.77	52.91	52.76	52.89	2959031.0
2007-10-08 13:00:00	QQQ	ETF	52.89	52.8922	52.85	52.8715	1051780.0
2007-10-08 13:30:00	QQQ	ETF	52.87	52.95	52.81	52.84	2066370.0
2007-10-08 14:00:00	QQQ	ETF	52.84	52.94	52.79	52.93	3419027.0
2007-10-08 14:30:00	QQQ	ETF	52.93	53.01	52.92	52.94	4249287.0
2007-10-08 15:00:00	QQQ	ETF	52.94	53.04	52.91	53.01	3748614.0
2007-10-08 15:30:00	QQQ	ETF	53.01	53.16	52.98	53.15	10419691.0

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

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