PREVIEW / etf_30min / 2009-10-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-14.parquet
  size:    240 KB
  rows:    7,986

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
2009-10-14 04:00:00	SPY	ETF	108.37	108.37	108.37	108.37	1150.0
2009-10-14 04:30:00	SPY	ETF	108.35	108.58	108.3	108.58	2000.0
2009-10-14 05:00:00	SPY	ETF	108.59	108.75	108.59	108.74	5600.0
2009-10-14 05:30:00	SPY	ETF	108.77	108.77	108.65	108.74	15500.0
2009-10-14 06:00:00	SPY	ETF	108.7	108.7	108.66	108.7	7093.0
2009-10-14 06:30:00	SPY	ETF	108.67	109.0	108.63	108.95	107600.0
2009-10-14 07:00:00	SPY	ETF	108.93	108.96	108.78	108.82	565090.0
2009-10-14 07:30:00	SPY	ETF	108.82	108.84	108.73	108.76	513418.0
2009-10-14 08:00:00	SPY	ETF	108.76	108.84	108.67	108.79	1212455.0
2009-10-14 08:30:00	SPY	ETF	108.8	108.9	107.5	108.83	2077335.0
2009-10-14 09:00:00	SPY	ETF	108.84	108.84	108.67	108.72	1993751.0
2009-10-14 09:30:00	SPY	ETF	108.72	108.79	108.35	108.56	24303800.0
2009-10-14 10:00:00	SPY	ETF	108.56	108.6	108.26	108.36	18271663.0
2009-10-14 10:30:00	SPY	ETF	108.36	108.67	108.3	108.58	9733794.0
2009-10-14 11:00:00	SPY	ETF	108.59	108.84	108.5	108.76	9307012.0
2009-10-14 11:30:00	SPY	ETF	108.76	108.83	108.65	108.76	7010176.0
2009-10-14 12:00:00	SPY	ETF	108.76	108.8	108.65	108.6799	6055841.0
2009-10-14 12:30:00	SPY	ETF	108.67	108.8	108.62	108.8	6453705.0
2009-10-14 13:00:00	SPY	ETF	108.8	108.98	108.77	108.81	11504120.0
2009-10-14 13:30:00	SPY	ETF	108.81	108.91	108.8	108.89	5322440.0
2009-10-14 14:00:00	SPY	ETF	108.89	109.0	108.5	108.88	11389596.0
2009-10-14 14:30:00	SPY	ETF	108.88	108.95	108.73	108.88	8860324.0
2009-10-14 15:00:00	SPY	ETF	108.88	109.38	108.87	109.35	19097571.0
2009-10-14 15:30:00	SPY	ETF	109.35	109.42	108.95	109.3207	28453645.0
2009-10-14 16:00:00	SPY	ETF	109.32	109.36	108.42	109.23	12195699.0
2009-10-14 16:30:00	SPY	ETF	109.22	109.35	109.19	109.32	3843812.0
2009-10-14 17:00:00	SPY	ETF	109.32	109.32	109.21	109.21	1190595.0
2009-10-14 17:30:00	SPY	ETF	109.24	109.27	109.22	109.22	30300.0
2009-10-14 18:00:00	SPY	ETF	109.21	109.24	109.18	109.24	23125.0
2009-10-14 18:30:00	SPY	ETF	109.25	109.34	109.25	109.31	11900.0
2009-10-14 19:00:00	SPY	ETF	109.31	109.34	109.31	109.32	6600.0
2009-10-14 19:30:00	SPY	ETF	109.33	109.36	109.3	109.35	38052.0
2009-10-14 04:30:00	QQQ	ETF	43.0	43.06	43.0	43.06	2200.0
2009-10-14 05:00:00	QQQ	ETF	43.1	43.1	43.1	43.1	5000.0
2009-10-14 05:30:00	QQQ	ETF	43.08	43.08	43.08	43.08	100.0
2009-10-14 06:00:00	QQQ	ETF	43.07	43.07	43.07	43.07	2500.0
2009-10-14 06:30:00	QQQ	ETF	43.07	43.18	43.07	43.18	29000.0
2009-10-14 07:00:00	QQQ	ETF	43.14	43.17	43.07	43.11	120629.0
2009-10-14 07:30:00	QQQ	ETF	43.11	43.14	43.1	43.14	157374.0
2009-10-14 08:00:00	QQQ	ETF	43.13	43.14	43.06	43.11	440303.0
2009-10-14 08:30:00	QQQ	ETF	43.12	43.15	43.09	43.14	695566.0
2009-10-14 09:00:00	QQQ	ETF	43.14	43.16	43.08	43.1	759891.0
2009-10-14 09:30:00	QQQ	ETF	43.1	43.12	42.85	42.95	18462665.0
2009-10-14 10:00:00	QQQ	ETF	42.94	43.02	42.89	42.92	9027582.0
2009-10-14 10:30:00	QQQ	ETF	42.92	42.97	42.8704	42.95	5474208.0
2009-10-14 11:00:00	QQQ	ETF	42.9569	43.293	42.9282	43.048	4230590.0
2009-10-14 11:30:00	QQQ	ETF	43.0476	43.081	43.01	43.03	3056462.0
2009-10-14 12:00:00	QQQ	ETF	43.02	43.04	42.97	42.998	3320342.0
2009-10-14 12:30:00	QQQ	ETF	42.99	43.05	42.95	43.05	4602222.0
2009-10-14 13:00:00	QQQ	ETF	43.0426	43.09	43.0	43.01	4211018.0

> showing 50 of 7,986 rows — these rows as CSV

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