PREVIEW / etf_30min / 2007-07-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-10.parquet
  size:    122 KB
  rows:    4,551

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-10 04:30:00	SPY	ETF	152.92	152.92	152.92	152.92	100.0
2007-07-10 06:00:00	SPY	ETF	152.78	152.83	152.78	152.83	17500.0
2007-07-10 06:30:00	SPY	ETF	152.83	152.83	152.8	152.8	1500.0
2007-07-10 07:00:00	SPY	ETF	152.84	152.84	152.66	152.68	512400.0
2007-07-10 07:30:00	SPY	ETF	152.71	152.71	152.56	152.6	347900.0
2007-07-10 08:00:00	SPY	ETF	152.6	152.83	152.44	152.5	1451500.0
2007-07-10 08:30:00	SPY	ETF	152.5	152.63	152.35	152.35	1072500.0
2007-07-10 09:00:00	SPY	ETF	152.35	152.6	152.16	152.26	4953550.0
2007-07-10 09:30:00	SPY	ETF	152.26	152.33	151.81	152.05	22322967.0
2007-07-10 10:00:00	SPY	ETF	152.05	152.36	151.89	152.165	14338174.0
2007-07-10 10:30:00	SPY	ETF	152.165	152.35	151.92	152.16	11411659.0
2007-07-10 11:00:00	SPY	ETF	152.16	152.61	152.16	152.32	11286422.0
2007-07-10 11:30:00	SPY	ETF	152.32	152.465	152.32	152.41	5096687.0
2007-07-10 12:00:00	SPY	ETF	152.41	152.52	152.11	152.16	3447147.0
2007-07-10 12:30:00	SPY	ETF	152.17	152.41	152.15	152.3	2531266.0
2007-07-10 13:00:00	SPY	ETF	152.3	152.5	151.92	152.01	11620131.0
2007-07-10 13:30:00	SPY	ETF	152.01	152.2	151.37	151.55	20398675.0
2007-07-10 14:00:00	SPY	ETF	151.55	151.82	151.27	151.71	17036101.0
2007-07-10 14:30:00	SPY	ETF	151.7	151.82	151.42	151.51	9738492.0
2007-07-10 15:00:00	SPY	ETF	151.5	151.6	151.21	151.43	14299920.0
2007-07-10 15:30:00	SPY	ETF	151.4375	151.45	150.87	150.89	16295667.0
2007-07-10 16:00:00	SPY	ETF	150.89	152.714	150.75	150.8	2701900.0
2007-07-10 16:30:00	SPY	ETF	150.84	150.96	150.8	150.86	3877700.0
2007-07-10 17:00:00	SPY	ETF	150.86	152.9	150.82	150.94	663800.0
2007-07-10 17:30:00	SPY	ETF	150.91	150.96	150.86	150.87	38200.0
2007-07-10 18:00:00	SPY	ETF	150.9	150.9	150.84	150.84	9100.0
2007-07-10 18:30:00	SPY	ETF	150.8	150.85	150.79	150.85	3100.0
2007-07-10 19:00:00	SPY	ETF	150.86	150.87	150.85	150.87	2300.0
2007-07-10 19:30:00	SPY	ETF	150.88	150.95	150.88	150.9	3800.0
2007-07-10 07:00:00	QQQ	ETF	48.77	48.77	48.73	48.73	706803.0
2007-07-10 07:30:00	QQQ	ETF	48.74	48.74	48.7	48.7	306790.0
2007-07-10 08:00:00	QQQ	ETF	48.71	48.72	48.64	48.68	1395940.0
2007-07-10 08:30:00	QQQ	ETF	48.69	48.72	48.67	48.67	334871.0
2007-07-10 09:00:00	QQQ	ETF	48.66	48.7	48.61	48.7	1251323.0
2007-07-10 09:30:00	QQQ	ETF	48.69	48.8	48.61	48.76	13412246.0
2007-07-10 10:00:00	QQQ	ETF	48.76	48.88	48.72	48.8	12108099.0
2007-07-10 10:30:00	QQQ	ETF	48.8	48.82	48.72	48.78	5360330.0
2007-07-10 11:00:00	QQQ	ETF	48.79	48.9	48.79	48.83	5625986.0
2007-07-10 11:30:00	QQQ	ETF	48.84	48.87	48.82	48.84	2713574.0
2007-07-10 12:00:00	QQQ	ETF	48.84	48.8785	48.76	48.78	2662663.0
2007-07-10 12:30:00	QQQ	ETF	48.78	48.84	48.75	48.77	3207194.0
2007-07-10 13:00:00	QQQ	ETF	48.77	48.83	48.69	48.7215	4210669.0
2007-07-10 13:30:00	QQQ	ETF	48.73	48.78	48.51	48.56	8455980.0
2007-07-10 14:00:00	QQQ	ETF	48.56	48.67	48.5	48.63	9269895.0
2007-07-10 14:30:00	QQQ	ETF	48.64	48.67	48.53	48.55	4286897.0
2007-07-10 15:00:00	QQQ	ETF	48.55	48.57	48.44	48.55	7274232.0
2007-07-10 15:30:00	QQQ	ETF	48.54	48.55	48.43	48.5	10648177.0
2007-07-10 16:00:00	QQQ	ETF	48.5	48.58	48.45	48.53	2247480.0
2007-07-10 16:30:00	QQQ	ETF	48.51	48.54	48.47	48.49	194944.0
2007-07-10 17:00:00	QQQ	ETF	48.5	48.53	48.49	48.53	1072.0

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

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