PREVIEW / etf_30min / 2007-03-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-12.parquet
  size:    100 KB
  rows:    3,452

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-03-12 06:00:00	SPY	ETF	140.98	140.98	140.98	140.98	5000.0
2007-03-12 06:30:00	SPY	ETF	140.87	140.87	140.87	140.87	500.0
2007-03-12 07:00:00	SPY	ETF	140.93	140.96	140.87	140.96	41100.0
2007-03-12 07:30:00	SPY	ETF	140.92	140.96	140.74	140.74	40100.0
2007-03-12 08:00:00	SPY	ETF	140.74	140.84	140.38	140.45	937700.0
2007-03-12 08:30:00	SPY	ETF	140.45	140.98	140.15	140.4	1548100.0
2007-03-12 09:00:00	SPY	ETF	140.33	140.41	140.27	140.41	790500.0
2007-03-12 09:30:00	SPY	ETF	140.42	140.65	140.16	140.26	9149500.0
2007-03-12 10:00:00	SPY	ETF	140.26	140.67	140.21	140.55	9507900.0
2007-03-12 10:30:00	SPY	ETF	140.55	140.57	140.32	140.43	3948500.0
2007-03-12 11:00:00	SPY	ETF	140.43	140.49	140.24	140.31	2936800.0
2007-03-12 11:30:00	SPY	ETF	140.31	140.49	140.26	140.4375	2891800.0
2007-03-12 12:00:00	SPY	ETF	140.44	140.78	140.39	140.5999	4102400.0
2007-03-12 12:30:00	SPY	ETF	140.59	140.72	140.51	140.71	3568100.0
2007-03-12 13:00:00	SPY	ETF	140.72	140.75	140.58	140.63	1506800.0
2007-03-12 13:30:00	SPY	ETF	140.63	140.75	140.56	140.74	2322200.0
2007-03-12 14:00:00	SPY	ETF	140.74	141.07	140.65	141.04	7897600.0
2007-03-12 14:30:00	SPY	ETF	141.05	141.34	141.02	141.21	10948900.0
2007-03-12 15:00:00	SPY	ETF	141.2	141.24	141.08	141.09	2592100.0
2007-03-12 15:30:00	SPY	ETF	141.08	141.0999	140.76	141.01	9124100.0
2007-03-12 16:00:00	SPY	ETF	141.01	141.02	140.94	140.99	2773800.0
2007-03-12 16:30:00	SPY	ETF	140.98	141.26	140.3	140.98	632700.0
2007-03-12 17:00:00	SPY	ETF	140.98	141.05	140.96	140.98	193100.0
2007-03-12 17:30:00	SPY	ETF	141.0	141.0	140.96	140.96	1000200.0
2007-03-12 18:30:00	SPY	ETF	140.96	140.97	140.95	140.95	7400.0
2007-03-12 19:00:00	SPY	ETF	140.97	140.97	140.91	140.91	4800.0
2007-03-12 19:30:00	SPY	ETF	140.92	140.93	140.91	140.92	5100.0
2007-03-12 04:00:00	QQQ	ETF	43.11	43.11	43.11	43.11	200.0
2007-03-12 06:00:00	QQQ	ETF	43.12	43.15	43.06	43.06	10700.0
2007-03-12 07:00:00	QQQ	ETF	43.1	43.13	43.1	43.13	20000.0
2007-03-12 07:30:00	QQQ	ETF	43.06	43.06	43.0	43.0	63200.0
2007-03-12 08:00:00	QQQ	ETF	43.0	43.01	42.88	42.91	309402.0
2007-03-12 08:30:00	QQQ	ETF	42.9	42.9	42.78	42.8	542963.0
2007-03-12 09:00:00	QQQ	ETF	42.8	42.87	42.8	42.87	430323.0
2007-03-12 09:30:00	QQQ	ETF	42.88	43.09	42.83	42.95	13487900.0
2007-03-12 10:00:00	QQQ	ETF	42.94	43.11	42.88	43.03	8880600.0
2007-03-12 10:30:00	QQQ	ETF	43.02	43.05	42.96	43.0	4052900.0
2007-03-12 11:00:00	QQQ	ETF	43.0	43.03	42.93	42.96	4034700.0
2007-03-12 11:30:00	QQQ	ETF	42.96	43.01	42.93	42.98	2463611.0
2007-03-12 12:00:00	QQQ	ETF	42.99	43.11	42.95	43.06	3894600.0
2007-03-12 12:30:00	QQQ	ETF	43.06	43.11	43.0	43.11	2519200.0
2007-03-12 13:00:00	QQQ	ETF	43.11	43.12	43.04	43.06	3073400.0
2007-03-12 13:30:00	QQQ	ETF	43.06	43.1	43.02	43.1	1730200.0
2007-03-12 14:00:00	QQQ	ETF	43.1	43.22	43.05	43.18	5372100.0
2007-03-12 14:30:00	QQQ	ETF	43.18	43.28	42.93	43.23	11475000.0
2007-03-12 15:00:00	QQQ	ETF	43.22	43.26	43.2	43.2	4350600.0
2007-03-12 15:30:00	QQQ	ETF	43.2	43.22	43.08	43.22	11298300.0
2007-03-12 16:00:00	QQQ	ETF	43.22	43.23	43.19	43.21	2049120.0
2007-03-12 16:30:00	QQQ	ETF	43.21	43.2475	42.995	43.18	316857.0
2007-03-12 17:00:00	QQQ	ETF	43.2	43.25	43.17	43.2	279968.0

> showing 50 of 3,452 rows — these rows as CSV

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